home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Power Programmierung
/
Power-Programmierung (Tewi)(1994).iso
/
magazine
/
dbms_mag
/
9102
/
gerrit1.feb
< prev
next >
Wrap
Text File
|
1990-12-17
|
333b
|
21 lines
Listing 1--CREATE TABLE commands
CREATE TABLE customer (
c# CHAR(5),
name CHAR(12),
city CHAR(15));
CREATE TABLE part (
p# CHAR(5),
pname CHAR(10),
color CHAR(10),
wt NUMERIC,
price NUMERIC);
CREATE TABLE invoice (
i# CHAR(5),
c# CHAR(5),
idate DATE);